class Tasks < ActiveRecord::Migration
  def self.up
    create_table "tasks", :force => true do |t|
      t.column :name,                      :string
      t.column :description,               :string
      t.column :assigned_to,               :integer
      t.column :project_id,                :integer
      t.column :activity_id,               :integer
      t.column :status,                    :string, :default => 'Waiting for approval'
      t.column :parent_id,                 :string
      t.column :projected_time,            :integer
      t.column :revision_no,               :integer
      t.column :start_date,                :date
      t.column :end_date,                  :date
      t.column :created_by,	               :integer
      t.column :created_at,                :datetime
      t.column :updated_at,                :datetime     
    end

  end

  def self.down
    drop_table "tasks"
  end
end
